This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Field is too large (32K) when removing a doc from a db ~Lorraine Desgerothernivu 27.Nov.03 11:00 AM a Web browser Applications Development 6.0.2 CF2Windows 2000
I think this is not the problem becase in the beginning it was working. Just now after a few days it did not work anymore.
I think the problme is not really on this line. I figured out that the db is way too big for what I use it. So, with the debugger I saw that I have about 3800 unprocessed documents in the database. This is a really strange because I have a view where the selection formula "Select @All" is and this view has just 692 documents.
If I let the agent run he already crashes with the first document. I check the document for nothing and I pass this. But in the debugger the docuemtn does even not have a creation date. It is a totally empty document. Just like freshly created.
So, something was going really odd with this db. I think I was messing up the database with my agents. I have two agents which are identical. One is just runnig on user request and the other every 30 minutes.
So if both agents runn at the same time they will produce unpredictable results because they search for the same documents in a database. So depending which agent runs a bit earlier or faster deletes a document of the other agent's collection.
This is what I think is the problem.
I need to work over the agents, so, they cannot be running at the same time.
Return to top
. . . . Field is too large (32K) when remov... (~Lorraine Desge... 27.Nov.03) 
Print this page
